Pandas Profiling Report

Dataset statistics

Number of variables	19
Number of observations	847
Missing cells	101
Missing cells (%)	0.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	125.9 KiB
Average record size in memory	152.2 B

Variable types

Categorical	9
Numeric	10

Alerts

`currency` has constant value "INR"	Constant
`title` has a high cardinality: 752 distinct values	High cardinality
`url` has a high cardinality: 847 distinct values	High cardinality
`product_id` has a high cardinality: 847 distinct values	High cardinality
`listing_id` has a high cardinality: 847 distinct values	High cardinality
`highlights` has a high cardinality: 489 distinct values	High cardinality
`selling_price` is highly correlated with `original_price` and 1 other fields	High correlation
`original_price` is highly correlated with `selling_price`	High correlation
`avg_rating` is highly correlated with `selling_price`	High correlation
`ratings_count` is highly correlated with `reviews_count` and 5 other fields	High correlation
`reviews_count` is highly correlated with `ratings_count` and 5 other fields	High correlation
`one_stars_count` is highly correlated with `ratings_count` and 5 other fields	High correlation
`two_stars_count` is highly correlated with `ratings_count` and 5 other fields	High correlation
`three_stars_count` is highly correlated with `ratings_count` and 5 other fields	High correlation
`four_stars_count` is highly correlated with `ratings_count` and 5 other fields	High correlation
`five_stars_count` is highly correlated with `ratings_count` and 5 other fields	High correlation
`selling_price` is highly correlated with `original_price`	High correlation
`original_price` is highly correlated with `selling_price`	High correlation
`ratings_count` is highly correlated with `reviews_count` and 5 other fields	High correlation
`reviews_count` is highly correlated with `ratings_count` and 5 other fields	High correlation
`one_stars_count` is highly correlated with `ratings_count` and 5 other fields	High correlation
`two_stars_count` is highly correlated with `ratings_count` and 5 other fields	High correlation
`three_stars_count` is highly correlated with `ratings_count` and 5 other fields	High correlation
`four_stars_count` is highly correlated with `ratings_count` and 5 other fields	High correlation
`five_stars_count` is highly correlated with `ratings_count` and 5 other fields	High correlation
`selling_price` is highly correlated with `original_price`	High correlation
`original_price` is highly correlated with `selling_price`	High correlation
`ratings_count` is highly correlated with `reviews_count` and 5 other fields	High correlation
`reviews_count` is highly correlated with `ratings_count` and 5 other fields	High correlation
`one_stars_count` is highly correlated with `ratings_count` and 5 other fields	High correlation
`two_stars_count` is highly correlated with `ratings_count` and 5 other fields	High correlation
`three_stars_count` is highly correlated with `ratings_count` and 5 other fields	High correlation
`four_stars_count` is highly correlated with `ratings_count` and 5 other fields	High correlation
`five_stars_count` is highly correlated with `ratings_count` and 5 other fields	High correlation
`currency` is highly correlated with `brand` and 2 other fields	High correlation
`brand` is highly correlated with `currency`	High correlation
`availability` is highly correlated with `currency`	High correlation
`ram` is highly correlated with `currency`	High correlation
`ram` is highly correlated with `brand` and 1 other fields	High correlation
`brand` is highly correlated with `ram` and 3 other fields	High correlation
`selling_price` is highly correlated with `brand` and 2 other fields	High correlation
`original_price` is highly correlated with `ram` and 2 other fields	High correlation
`avg_rating` is highly correlated with `brand` and 1 other fields	High correlation
`ratings_count` is highly correlated with `reviews_count` and 5 other fields	High correlation
`reviews_count` is highly correlated with `ratings_count` and 5 other fields	High correlation
`one_stars_count` is highly correlated with `ratings_count` and 5 other fields	High correlation
`two_stars_count` is highly correlated with `ratings_count` and 5 other fields	High correlation
`three_stars_count` is highly correlated with `ratings_count` and 5 other fields	High correlation
`four_stars_count` is highly correlated with `ratings_count` and 5 other fields	High correlation
`five_stars_count` is highly correlated with `ratings_count` and 5 other fields	High correlation
`ram` has 101 (11.9%) missing values	Missing
`title` is uniformly distributed	Uniform
`url` is uniformly distributed	Uniform
`product_id` is uniformly distributed	Uniform
`listing_id` is uniformly distributed	Uniform
`highlights` is uniformly distributed	Uniform
`url` has unique values	Unique
`product_id` has unique values	Unique
`listing_id` has unique values	Unique
`avg_rating` has 22 (2.6%) zeros	Zeros
`ratings_count` has 22 (2.6%) zeros	Zeros
`reviews_count` has 32 (3.8%) zeros	Zeros
`one_stars_count` has 39 (4.6%) zeros	Zeros
`two_stars_count` has 44 (5.2%) zeros	Zeros
`three_stars_count` has 34 (4.0%) zeros	Zeros
`four_stars_count` has 33 (3.9%) zeros	Zeros
`five_stars_count` has 22 (2.6%) zeros	Zeros

Reproduction

Analysis started	2022-08-13 09:30:21.287360
Analysis finished	2022-08-13 09:32:05.526817
Duration	1 minute and 44.24 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

title
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	752
Distinct (%)	88.8%
Missing	0
Missing (%)	0.0%
Memory size	6.7 KiB

REDMI Note 10S (Deep Sea Blue, 128 GB)	4
REDMI Note 10 Pro (Vintage Bronze, 128 GB)	3
REDMI Note 10 Pro (Dark Night, 128 GB)	3
vivo T1 5G (Rainbow Fantasy, 128 GB)	3
REDMI Note 10S (Cosmic Purple, 128 GB)	3
Other values (747)	831

Length

Max length	58
Median length	52
Mean length	35.45336482
Min length	21

Characters and Unicode

Total characters	30029
Distinct characters	72
Distinct categories	11 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	667 ?
Unique (%)	78.7%

Sample

1st row	POCO C31 (Royal Blue, 64 GB)
2nd row	POCO C31 (Shadow Gray, 64 GB)
3rd row	realme C35 (Glowing Green, 64 GB)
4th row	OPPO K10 (Black Carbon, 128 GB)
5th row	MOTOROLA G60 (Soft Silver, 128 GB)

Common Values

Value	Count	Frequency (%)
REDMI Note 10S (Deep Sea Blue, 128 GB)	4	0.5%
REDMI Note 10 Pro (Vintage Bronze, 128 GB)	3	0.4%
REDMI Note 10 Pro (Dark Night, 128 GB)	3	0.4%
vivo T1 5G (Rainbow Fantasy, 128 GB)	3	0.4%
REDMI Note 10S (Cosmic Purple, 128 GB)	3	0.4%
SAMSUNG Galaxy A12 (Black, 128 GB)	3	0.4%
vivo T1 5G (Starlight Black, 128 GB)	3	0.4%
REDMI Note 10S (Frost White, 128 GB)	3	0.4%
SAMSUNG Galaxy A12 (Blue, 128 GB)	3	0.4%
REDMI Note 10T 5G (Graphite Black, 128 GB)	2	0.2%
Other values (742)	817	96.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
gb	839	14.4%
128	369	6.3%
64	240	4.1%
blue	218	3.7%
black	212	3.6%
5g	146	2.5%
pro	142	2.4%
32	135	2.3%
redmi	131	2.3%
realme	114	2.0%
Other values (540)	3275	56.3%

Most occurring characters

Value	Count	Frequency (%)
	4974	16.6%
e	1557	5.2%
G	1452	4.8%
B	1303	4.3%
a	1151	3.8%
l	1031	3.4%
i	1014	3.4%
o	929	3.1%
r	913	3.0%
)	867	2.9%
Other values (62)	14838	49.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	11184	37.2%
Uppercase Letter	7581	25.2%
Space Separator	4974	16.6%
Decimal Number	3678	12.2%
Close Punctuation	867	2.9%
Open Punctuation	867	2.9%
Other Punctuation	851	2.8%
Math Symbol	11	< 0.1%
Dash Punctuation	7	< 0.1%
Other Symbol	5	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1557	13.9%
a	1151	10.3%
l	1031	9.2%
i	1014	9.1%
o	929	8.3%
r	913	8.2%
n	681	6.1%
t	564	5.0%
c	420	3.8%
u	383	3.4%
Other values (16)	2541	22.7%

Uppercase Letter

Value	Count	Frequency (%)
G	1452	19.2%
B	1303	17.2%
P	752	9.9%
M	495	6.5%
S	495	6.5%
A	481	6.3%
O	337	4.4%
E	312	4.1%
N	292	3.9%
R	255	3.4%
Other values (16)	1407	18.6%

Decimal Number

Value	Count	Frequency (%)
1	849	23.1%
2	836	22.7%
8	424	11.5%
6	352	9.6%
5	330	9.0%
3	299	8.1%
4	283	7.7%
0	177	4.8%
9	85	2.3%
7	43	1.2%

Other Punctuation

Value	Count	Frequency (%)
,	848	99.6%
.	3	0.4%

Math Symbol

Value	Count	Frequency (%)
+	9	81.8%
\|	2	18.2%

Space Separator

Value	Count	Frequency (%)
	4974	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	867	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	867	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	7	100.0%

Other Symbol

Value	Count	Frequency (%)
°	5	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	4	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	18765	62.5%
Common	11264	37.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1557	8.3%
G	1452	7.7%
B	1303	6.9%
a	1151	6.1%
l	1031	5.5%
i	1014	5.4%
o	929	5.0%
r	913	4.9%
P	752	4.0%
n	681	3.6%
Other values (42)	7982	42.5%

Common

Value	Count	Frequency (%)
	4974	44.2%
)	867	7.7%
(	867	7.7%
1	849	7.5%
,	848	7.5%
2	836	7.4%
8	424	3.8%
6	352	3.1%
5	330	2.9%
3	299	2.7%
Other values (10)	618	5.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	30024	> 99.9%
None	5	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	4974	16.6%
e	1557	5.2%
G	1452	4.8%
B	1303	4.3%
a	1151	3.8%
l	1031	3.4%
i	1014	3.4%
o	929	3.1%
r	913	3.0%
)	867	2.9%
Other values (61)	14833	49.4%

None

Value	Count	Frequency (%)
°	5	100.0%

ram
Categorical

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	7
Distinct (%)	0.9%
Missing	101
Missing (%)	11.9%
Memory size	6.7 KiB

4 GB RAM	211
6 GB RAM	183
8 GB RAM	158
3 GB RAM	87
2 GB RAM	81
Other values (2)	26

Length

Max length	9
Median length	8
Mean length	8.018766756
Min length	8

Characters and Unicode

Total characters	5982
Distinct characters	12
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4 GB RAM
2nd row	4 GB RAM
3rd row	4 GB RAM
4th row	6 GB RAM
5th row	6 GB RAM

Common Values

Value	Count	Frequency (%)
4 GB RAM	211	24.9%
6 GB RAM	183	21.6%
8 GB RAM	158	18.7%
3 GB RAM	87	10.3%
2 GB RAM	81	9.6%
12 GB RAM	14	1.7%
1 GB RAM	12	1.4%
(Missing)	101	11.9%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
gb	746	33.3%
ram	746	33.3%
4	211	9.4%
6	183	8.2%
8	158	7.1%
3	87	3.9%
2	81	3.6%
12	14	0.6%
1	12	0.5%

Most occurring characters

Value	Count	Frequency (%)
	1492	24.9%
G	746	12.5%
B	746	12.5%
R	746	12.5%
A	746	12.5%
M	746	12.5%
4	211	3.5%
6	183	3.1%
8	158	2.6%
2	95	1.6%
Other values (2)	113	1.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	3730	62.4%
Space Separator	1492	24.9%
Decimal Number	760	12.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
4	211	27.8%
6	183	24.1%
8	158	20.8%
2	95	12.5%
3	87	11.4%
1	26	3.4%

Uppercase Letter

Value	Count	Frequency (%)
G	746	20.0%
B	746	20.0%
R	746	20.0%
A	746	20.0%
M	746	20.0%

Space Separator

Value	Count	Frequency (%)
	1492	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3730	62.4%
Common	2252	37.6%

Most frequent character per script

Common

Value	Count	Frequency (%)
	1492	66.3%
4	211	9.4%
6	183	8.1%
8	158	7.0%
2	95	4.2%
3	87	3.9%
1	26	1.2%

Latin

Value	Count	Frequency (%)
G	746	20.0%
B	746	20.0%
R	746	20.0%
A	746	20.0%
M	746	20.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5982	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	1492	24.9%
G	746	12.5%
B	746	12.5%
R	746	12.5%
A	746	12.5%
M	746	12.5%
4	211	3.5%
6	183	3.1%
8	158	2.6%
2	95	1.6%
Other values (2)	113	1.9%

brand
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	27
Distinct (%)	3.2%
Missing	0
Missing (%)	0.0%
Memory size	6.7 KiB

realme	114
SAMSUNG	109
APPLE	101
REDMI	83
Mi	75
Other values (22)	365

Length

Max length	16
Median length	9
Mean length	5.18772137
Min length	2

Characters and Unicode

Total characters	4394
Distinct characters	42
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	0.4%

Sample

1st row	POCO
2nd row	POCO
3rd row	realme
4th row	OPPO
5th row	MOTOROLA

Common Values

Value	Count	Frequency (%)
realme	114	13.5%
SAMSUNG	109	12.9%
APPLE	101	11.9%
REDMI	83	9.8%
Mi	75	8.9%
OPPO	67	7.9%
vivo	64	7.6%
Infinix	44	5.2%
Tecno	36	4.3%
POCO	33	3.9%
Other values (17)	121	14.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
realme	114	13.4%
samsung	109	12.8%
apple	101	11.9%
redmi	83	9.8%
mi	75	8.8%
oppo	67	7.9%
vivo	64	7.5%
infinix	44	5.2%
tecno	36	4.2%
poco	33	3.9%
Other values (19)	125	14.7%

Most occurring characters

Value	Count	Frequency (%)
P	371	8.4%
M	315	7.2%
O	293	6.7%
e	290	6.6%
A	262	6.0%
i	261	5.9%
S	230	5.2%
E	204	4.6%
I	160	3.6%
a	160	3.6%
Other values (32)	1848	42.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2655	60.4%
Lowercase Letter	1735	39.5%
Space Separator	4	0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
P	371	14.0%
M	315	11.9%
O	293	11.0%
A	262	9.9%
S	230	8.7%
E	204	7.7%
I	160	6.0%
L	138	5.2%
N	131	4.9%
G	119	4.5%
Other values (13)	432	16.3%

Lowercase Letter

Value	Count	Frequency (%)
e	290	16.7%
i	261	15.0%
a	160	9.2%
l	158	9.1%
n	137	7.9%
o	131	7.6%
r	129	7.4%
v	128	7.4%
m	126	7.3%
x	56	3.2%
Other values (8)	159	9.2%

Space Separator

Value	Count	Frequency (%)
	4	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4390	99.9%
Common	4	0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
P	371	8.5%
M	315	7.2%
O	293	6.7%
e	290	6.6%
A	262	6.0%
i	261	5.9%
S	230	5.2%
E	204	4.6%
I	160	3.6%
a	160	3.6%
Other values (31)	1844	42.0%

Common

Value	Count	Frequency (%)
	4	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4394	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
P	371	8.4%
M	315	7.2%
O	293	6.7%
e	290	6.6%
A	262	6.0%
i	261	5.9%
S	230	5.2%
E	204	4.6%
I	160	3.6%
a	160	3.6%
Other values (32)	1848	42.1%

url
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	847
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	6.7 KiB

https://www.flipkart.com/poco-c31-royal-blue-64-gb/p/itm19effae969b86?pid=MOBG73E7GKQK4KZP	1
https://www.flipkart.com/realme-7-mist-white-128-gb/p/itme55d08631f19b?pid=MOBFUYUNHENTTY9M	1
https://www.flipkart.com/apple-iphone-13-pro-graphite-256-gb/p/itm1b16c87a4a64a?pid=MOBG6VF5WKMAADTZ	1
https://www.flipkart.com/xiaomi-11t-pro-5g-hyperphone-moonlight-white-256-gb/p/itmc9e9597986ec5?pid=MOBGB74URFDJ3EGH	1
https://www.flipkart.com/oppo-f9-pro-starry-purple-64-gb/p/itmf8fczgnrn5xhy?pid=MOBF8FCZHK2HWJVT	1
Other values (842)	842

Length

Max length	116
Median length	108
Mean length	97.18181818
Min length	83

Characters and Unicode

Total characters	82313
Distinct characters	66
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	847 ?
Unique (%)	100.0%

Sample

1st row	https://www.flipkart.com/poco-c31-royal-blue-64-gb/p/itm19effae969b86?pid=MOBG73E7GKQK4KZP
2nd row	https://www.flipkart.com/poco-c31-shadow-gray-64-gb/p/itm162375acb8370?pid=MOBG73E7UBFXXMCH
3rd row	https://www.flipkart.com/realme-c35-glowing-green-64-gb/p/itmafb045222b2cf?pid=MOBGBTHFSKHF8RAU
4th row	https://www.flipkart.com/oppo-k10-black-carbon-128-gb/p/itm6205e7e72fe0c?pid=MOBGCFUHMDFSCM9W
5th row	https://www.flipkart.com/motorola-g60-soft-silver-128-gb/p/itm7d158ff189510?pid=MOBG9CJ6G5GCFAH4

Common Values

Value	Count	Frequency (%)
https://www.flipkart.com/poco-c31-royal-blue-64-gb/p/itm19effae969b86?pid=MOBG73E7GKQK4KZP	1	0.1%
https://www.flipkart.com/realme-7-mist-white-128-gb/p/itme55d08631f19b?pid=MOBFUYUNHENTTY9M	1	0.1%
https://www.flipkart.com/apple-iphone-13-pro-graphite-256-gb/p/itm1b16c87a4a64a?pid=MOBG6VF5WKMAADTZ	1	0.1%
https://www.flipkart.com/xiaomi-11t-pro-5g-hyperphone-moonlight-white-256-gb/p/itmc9e9597986ec5?pid=MOBGB74URFDJ3EGH	1	0.1%
https://www.flipkart.com/oppo-f9-pro-starry-purple-64-gb/p/itmf8fczgnrn5xhy?pid=MOBF8FCZHK2HWJVT	1	0.1%
https://www.flipkart.com/motorola-g40-fusion-frosted-champagne-64-gb/p/itmaa22c25971ee0?pid=MOBFWSF8KRVUGH9W	1	0.1%
https://www.flipkart.com/vivo-y51a-crystal-symphony-128-gb/p/itm72ed89f10c598?pid=MOBFZ2U4GURCS37U	1	0.1%
https://www.flipkart.com/oppo-f19-pro-fantastic-purple-256-gb/p/itmf3153ba8dbf1a?pid=MOBGYV9VUGTPFWRY	1	0.1%
https://www.flipkart.com/samsung-galaxy-m11-metallic-blue-64-gb/p/itm1a7c4dfe52d9c?pid=MOBFRZZHZGSRRWUZ	1	0.1%
https://www.flipkart.com/apple-iphone-se-3rd-gen-midnight-256-gb/p/itm06824d5671624?pid=MOBGC9K3EMZYFNDT	1	0.1%
Other values (837)	837	98.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
https://www.flipkart.com/poco-c31-royal-blue-64-gb/p/itm19effae969b86?pid=mobg73e7gkqk4kzp	1	0.1%
https://www.flipkart.com/oppo-a54-starry-blue-128-gb/p/itm2c71eaacf710e?pid=mobg23kttgynzfrm	1	0.1%
https://www.flipkart.com/realme-9i-prism-black-128-gb/p/itm3e9987219f652?pid=mobgbmzh9x7pqzjz	1	0.1%
https://www.flipkart.com/realme-c35-glowing-green-64-gb/p/itmafb045222b2cf?pid=mobgbthfskhf8rau	1	0.1%
https://www.flipkart.com/oppo-k10-black-carbon-128-gb/p/itm6205e7e72fe0c?pid=mobgcfuhmdfscm9w	1	0.1%
https://www.flipkart.com/motorola-g60-soft-silver-128-gb/p/itm7d158ff189510?pid=mobg9cj6g5gcfah4	1	0.1%
https://www.flipkart.com/realme-c20-cool-grey-32-gb/p/itmea1903897436b?pid=mobgf489sqzcfhya	1	0.1%
https://www.flipkart.com/realme-c20-cool-blue-32-gb/p/itmea1903897436b?pid=mobgf4894mewzjgv	1	0.1%
https://www.flipkart.com/poco-c31-royal-blue-32-gb/p/itm9656ebd21e0b3?pid=mobg73e7zbhhq3rb	1	0.1%
https://www.flipkart.com/realme-9i-prism-blue-64-gb/p/itm3e9987219f652?pid=mobg9vgvkum4xnrr	1	0.1%
Other values (837)	837	98.8%

Most occurring characters

Value	Count	Frequency (%)
-	4958	6.0%
p	4343	5.3%
/	4235	5.1%
t	4109	5.0%
i	3718	4.5%
a	3138	3.8%
w	2709	3.3%
e	2558	3.1%
m	2541	3.1%
c	2114	2.6%
Other values (56)	47890	58.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	45202	54.9%
Decimal Number	12019	14.6%
Uppercase Letter	11664	14.2%
Other Punctuation	7623	9.3%
Dash Punctuation	4958	6.0%
Math Symbol	847	1.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
p	4343	9.6%
t	4109	9.1%
i	3718	8.2%
a	3138	6.9%
w	2709	6.0%
e	2558	5.7%
m	2541	5.6%
c	2114	4.7%
o	2096	4.6%
l	2056	4.5%
Other values (16)	15820	35.0%

Uppercase Letter

Value	Count	Frequency (%)
G	1271	10.9%
B	1244	10.7%
M	1106	9.5%
O	847	7.3%
F	789	6.8%
H	555	4.8%
Y	540	4.6%
Z	528	4.5%
W	349	3.0%
K	339	2.9%
Other values (14)	4096	35.1%

Decimal Number

Value	Count	Frequency (%)
2	1731	14.4%
1	1435	11.9%
8	1345	11.2%
5	1280	10.6%
6	1269	10.6%
3	1196	10.0%
4	1171	9.7%
9	962	8.0%
7	841	7.0%
0	789	6.6%

Other Punctuation

Value	Count	Frequency (%)
/	4235	55.6%
.	1694	22.2%
?	847	11.1%
:	847	11.1%

Dash Punctuation

Value	Count	Frequency (%)
-	4958	100.0%

Math Symbol

Value	Count	Frequency (%)
=	847	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	56866	69.1%
Common	25447	30.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
p	4343	7.6%
t	4109	7.2%
i	3718	6.5%
a	3138	5.5%
w	2709	4.8%
e	2558	4.5%
m	2541	4.5%
c	2114	3.7%
o	2096	3.7%
l	2056	3.6%
Other values (40)	27484	48.3%

Common

Value	Count	Frequency (%)
-	4958	19.5%
/	4235	16.6%
2	1731	6.8%
.	1694	6.7%
1	1435	5.6%
8	1345	5.3%
5	1280	5.0%
6	1269	5.0%
3	1196	4.7%
4	1171	4.6%
Other values (6)	5133	20.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	82313	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
-	4958	6.0%
p	4343	5.3%
/	4235	5.1%
t	4109	5.0%
i	3718	4.5%
a	3138	3.8%
w	2709	3.3%
e	2558	3.1%
m	2541	3.1%
c	2114	2.6%
Other values (56)	47890	58.2%

product_id
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	847
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	6.7 KiB

MOBG73E7GKQK4KZP	1
MOBFUYUNHENTTY9M	1
MOBG6VF5WKMAADTZ	1
MOBGB74URFDJ3EGH	1
MOBF8FCZHK2HWJVT	1
Other values (842)	842

Length

Max length	16
Median length	16
Mean length	16
Min length	16

Characters and Unicode

Total characters	13552
Distinct characters	32
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	847 ?
Unique (%)	100.0%

Sample

1st row	MOBG73E7GKQK4KZP
2nd row	MOBG73E7UBFXXMCH
3rd row	MOBGBTHFSKHF8RAU
4th row	MOBGCFUHMDFSCM9W
5th row	MOBG9CJ6G5GCFAH4

Common Values

Value	Count	Frequency (%)
MOBG73E7GKQK4KZP	1	0.1%
MOBFUYUNHENTTY9M	1	0.1%
MOBG6VF5WKMAADTZ	1	0.1%
MOBGB74URFDJ3EGH	1	0.1%
MOBF8FCZHK2HWJVT	1	0.1%
MOBFWSF8KRVUGH9W	1	0.1%
MOBFZ2U4GURCS37U	1	0.1%
MOBGYV9VUGTPFWRY	1	0.1%
MOBFRZZHZGSRRWUZ	1	0.1%
MOBGC9K3EMZYFNDT	1	0.1%
Other values (837)	837	98.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
mobg73e7gkqk4kzp	1	0.1%
mobg23kttgynzfrm	1	0.1%
mobgbmzh9x7pqzjz	1	0.1%
mobgbthfskhf8rau	1	0.1%
mobgcfuhmdfscm9w	1	0.1%
mobg9cj6g5gcfah4	1	0.1%
mobgf489sqzcfhya	1	0.1%
mobgf4894mewzjgv	1	0.1%
mobg73e7zbhhq3rb	1	0.1%
mobg9vgvkum4xnrr	1	0.1%
Other values (837)	837	98.8%

Most occurring characters

Value	Count	Frequency (%)
G	1271	9.4%
B	1244	9.2%
M	1106	8.2%
O	847	6.2%
F	789	5.8%
H	555	4.1%
Y	540	4.0%
Z	528	3.9%
W	349	2.6%
K	339	2.5%
Other values (22)	5984	44.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	11664	86.1%
Decimal Number	1888	13.9%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
G	1271	10.9%
B	1244	10.7%
M	1106	9.5%
O	847	7.3%
F	789	6.8%
H	555	4.8%
Y	540	4.6%
Z	528	4.5%
W	349	3.0%
K	339	2.9%
Other values (14)	4096	35.1%

Decimal Number

Value	Count	Frequency (%)
5	277	14.7%
6	272	14.4%
8	240	12.7%
9	239	12.7%
4	231	12.2%
2	217	11.5%
3	215	11.4%
7	197	10.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	11664	86.1%
Common	1888	13.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
G	1271	10.9%
B	1244	10.7%
M	1106	9.5%
O	847	7.3%
F	789	6.8%
H	555	4.8%
Y	540	4.6%
Z	528	4.5%
W	349	3.0%
K	339	2.9%
Other values (14)	4096	35.1%

Common

Value	Count	Frequency (%)
5	277	14.7%
6	272	14.4%
8	240	12.7%
9	239	12.7%
4	231	12.2%
2	217	11.5%
3	215	11.4%
7	197	10.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	13552	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
G	1271	9.4%
B	1244	9.2%
M	1106	8.2%
O	847	6.2%
F	789	5.8%
H	555	4.1%
Y	540	4.0%
Z	528	3.9%
W	349	2.6%
K	339	2.5%
Other values (22)	5984	44.2%

listing_id
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	847
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	6.7 KiB

LSTMOBG73E7GKQK4KZPR5ICMK	1
LSTMOBFUYUNHENTTY9MSTBB71	1
LSTMOBG6VF5WKMAADTZP6DVL2	1
LSTMOBGB74URFDJ3EGHWPSDGQ	1
LSTMOBF8FCZHK2HWJVTLHKVJA	1
Other values (842)	842

Length

Max length	25
Median length	25
Mean length	25
Min length	25

Characters and Unicode

Total characters	21175
Distinct characters	36
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	847 ?
Unique (%)	100.0%

Sample

1st row	LSTMOBG73E7GKQK4KZPR5ICMK
2nd row	LSTMOBG73E7UBFXXMCHSM0ZN5
3rd row	LSTMOBGBTHFSKHF8RAUQONXWY
4th row	LSTMOBGCFUHMDFSCM9WSL0U8O
5th row	LSTMOBG9CJ6G5GCFAH4CCXVXL

Common Values

Value	Count	Frequency (%)
LSTMOBG73E7GKQK4KZPR5ICMK	1	0.1%
LSTMOBFUYUNHENTTY9MSTBB71	1	0.1%
LSTMOBG6VF5WKMAADTZP6DVL2	1	0.1%
LSTMOBGB74URFDJ3EGHWPSDGQ	1	0.1%
LSTMOBF8FCZHK2HWJVTLHKVJA	1	0.1%
LSTMOBFWSF8KRVUGH9WJ4EGIM	1	0.1%
LSTMOBFZ2U4GURCS37UYYS09Z	1	0.1%
LSTMOBGYV9VUGTPFWRYJFN6FU	1	0.1%
LSTMOBFRZZHZGSRRWUZY4LQJU	1	0.1%
LSTMOBGC9K3EMZYFNDTWRLKFS	1	0.1%
Other values (837)	837	98.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
lstmobg73e7gkqk4kzpr5icmk	1	0.1%
lstmobg23kttgynzfrmyw1a2d	1	0.1%
lstmobgbmzh9x7pqzjznqtn2q	1	0.1%
lstmobgbthfskhf8rauqonxwy	1	0.1%
lstmobgcfuhmdfscm9wsl0u8o	1	0.1%
lstmobg9cj6g5gcfah4ccxvxl	1	0.1%
lstmobgf489sqzcfhyagb7sds	1	0.1%
lstmobgf4894mewzjgvw425n5	1	0.1%
lstmobg73e7zbhhq3rbdyspvo	1	0.1%
lstmobg9vgvkum4xnrrjw5ynz	1	0.1%
Other values (837)	837	98.8%

Most occurring characters

Value	Count	Frequency (%)
G	1427	6.7%
B	1404	6.6%
T	1311	6.2%
S	1283	6.1%
M	1275	6.0%
O	1019	4.8%
L	1004	4.7%
F	946	4.5%
H	718	3.4%
Y	702	3.3%
Other values (26)	10086	47.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	18459	87.2%
Decimal Number	2716	12.8%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
G	1427	7.7%
B	1404	7.6%
T	1311	7.1%
S	1283	7.0%
M	1275	6.9%
O	1019	5.5%
L	1004	5.4%
F	946	5.1%
H	718	3.9%
Y	702	3.8%
Other values (16)	7370	39.9%

Decimal Number

Value	Count	Frequency (%)
5	360	13.3%
6	343	12.6%
9	331	12.2%
8	325	12.0%
4	314	11.6%
2	306	11.3%
3	279	10.3%
7	277	10.2%
1	91	3.4%
0	90	3.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	18459	87.2%
Common	2716	12.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
G	1427	7.7%
B	1404	7.6%
T	1311	7.1%
S	1283	7.0%
M	1275	6.9%
O	1019	5.5%
L	1004	5.4%
F	946	5.1%
H	718	3.9%
Y	702	3.8%
Other values (16)	7370	39.9%

Common

Value	Count	Frequency (%)
5	360	13.3%
6	343	12.6%
9	331	12.2%
8	325	12.0%
4	314	11.6%
2	306	11.3%
3	279	10.3%
7	277	10.2%
1	91	3.4%
0	90	3.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	21175	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
G	1427	6.7%
B	1404	6.6%
T	1311	6.2%
S	1283	6.1%
M	1275	6.0%
O	1019	4.8%
L	1004	4.7%
F	946	4.5%
H	718	3.4%
Y	702	3.3%
Other values (26)	10086	47.6%

highlights
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	489
Distinct (%)	57.7%
Missing	0
Missing (%)	0.0%
Memory size	6.7 KiB

128 GB ROM 13.72 cm (5.4 inch) Super Retina XDR Display 12MP + 12MP \| 12MP Front Camera A15 Bionic Chip Processor	6
128 GB ROM 15.49 cm (6.1 inch) Super Retina XDR Display 12MP + 12MP \| 12MP Front Camera A15 Bionic Chip Processor	5
64 GB ROM 15.49 cm (6.1 inch) Liquid Retina HD Display 12MP + 12MP \| 12MP Front Camera A13 Bionic Chip Processor	5
3 GB RAM \| 32 GB ROM \| Expandable Upto 512 GB 16.59 cm (6.53 inch) HD+ Display 13MP Rear Camera \| 5MP Front Camera 5000 mAh Battery MediaTek Helio G25 Processor	5
128 GB ROM 13.72 cm (5.4 inch) Super Retina XDR Display 12MP + 12MP \| 12MP Front Camera A14 Bionic Chip with Next Generation Neural Engine Processor Ceramic Shield Industry-leading IP68 Water Resistance All Screen OLED Display 12MP TrueDepth Front Camera with Night Mode, 4K Dolby Vision HDR Recording	4
Other values (484)	822

Length

Max length	420
Median length	248
Mean length	171.0177096
Min length	81

Characters and Unicode

Total characters	144852
Distinct characters	75
Distinct categories	10 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	236 ?
Unique (%)	27.9%

Sample

1st row	4 GB RAM \| 64 GB ROM \| Expandable Upto 512 GB 16.59 cm (6.53 inch) HD+ Display 13MP + 2MP + 2MP \| 5MP Front Camera 5000 mAh Lithium-ion Polymer Battery MediaTek Helio G35 Processor
2nd row	4 GB RAM \| 64 GB ROM \| Expandable Upto 512 GB 16.59 cm (6.53 inch) HD+ Display 13MP + 2MP + 2MP \| 5MP Front Camera 5000 mAh Lithium-ion Polymer Battery MediaTek Helio G35 Processor
3rd row	4 GB RAM \| 64 GB ROM \| Expandable Upto 1 TB 16.76 cm (6.6 inch) Full HD+ Display 50MP + 2MP + 0.3MP \| 8MP Front Camera 5000 mAh Lithium Polymer Battery Unisoc Tiger T616 Processor
4th row	6 GB RAM \| 128 GB ROM \| Expandable Upto 1 TB 16.74 cm (6.59 inch) Full HD+ Display 50MP + 2MP + 2MP \| 16MP Front Camera 5000 mAh Lithium Ion Battery Qualcomm Snapdragon 680 Processor 33W SUPERVOOC Charger \| Dual Speaker \| Super Adaptive Refresh Rate AI Photo Suite \| OPPO Glow Design with Dirt and Scratch Resistant
5th row	6 GB RAM \| 128 GB ROM 17.22 cm (6.78 inch) Full HD+ Display 108MP + 8MP + 2MP \| 32MP Front Camera 6000 mAh Battery Qualcomm Snapdragon 732G Processor 120Hz Refresh Rate Stock Android Experience

Common Values

Value	Count	Frequency (%)
128 GB ROM 13.72 cm (5.4 inch) Super Retina XDR Display 12MP + 12MP \| 12MP Front Camera A15 Bionic Chip Processor	6	0.7%
128 GB ROM 15.49 cm (6.1 inch) Super Retina XDR Display 12MP + 12MP \| 12MP Front Camera A15 Bionic Chip Processor	5	0.6%
64 GB ROM 15.49 cm (6.1 inch) Liquid Retina HD Display 12MP + 12MP \| 12MP Front Camera A13 Bionic Chip Processor	5	0.6%
3 GB RAM \| 32 GB ROM \| Expandable Upto 512 GB 16.59 cm (6.53 inch) HD+ Display 13MP Rear Camera \| 5MP Front Camera 5000 mAh Battery MediaTek Helio G25 Processor	5	0.6%
128 GB ROM 13.72 cm (5.4 inch) Super Retina XDR Display 12MP + 12MP \| 12MP Front Camera A14 Bionic Chip with Next Generation Neural Engine Processor Ceramic Shield Industry-leading IP68 Water Resistance All Screen OLED Display 12MP TrueDepth Front Camera with Night Mode, 4K Dolby Vision HDR Recording	4	0.5%
256 GB ROM 13.72 cm (5.4 inch) Super Retina XDR Display 12MP + 12MP \| 12MP Front Camera A15 Bionic Chip Processor	4	0.5%
4 GB RAM \| 128 GB ROM \| Expandable Upto 256 GB 17.22 cm (6.78 inch) Full HD+ Display 50 MP + 2 MP + AI Lens \| 8MP Front Camera 5000 mAh Li-ion Polymer Battery Mediatek Helio G88 Processor	4	0.5%
64 GB ROM 15.49 cm (6.1 inch) Super Retina XDR Display 12MP + 12MP \| 12MP Front Camera A14 Bionic Chip with Next Generation Neural Engine Processor Ceramic Shield Industry-leading IP68 Water Resistance All Screen OLED Display 12MP TrueDepth Front Camera with Night Mode, 4K Dolby Vision HDR Recording	4	0.5%
6 GB RAM \| 128 GB ROM \| Expandable Upto 1 TB 16.94 cm (6.67 inch) Full HD+ AMOLED Display 108MP Rear Camera \| 16MP Front Camera 5160 mAh Li-Polymer Battery Mediatek Dimensity 920 Processor	4	0.5%
128 GB ROM 17.02 cm (6.7 inch) Super Retina XDR Display 12MP + 12MP + 12MP \| 12MP Front Camera A15 Bionic Chip Processor	4	0.5%
Other values (479)	802	94.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	3324	11.5%
gb	1958	6.8%
camera	1036	3.6%
display	921	3.2%
rom	847	2.9%
cm	847	2.9%
inch	847	2.9%
processor	779	2.7%
front	777	2.7%
battery	753	2.6%
Other values (585)	16734	58.1%

Most occurring characters

Value	Count	Frequency (%)
	27976	19.3%
a	6793	4.7%
e	6032	4.2%
r	5746	4.0%
M	4979	3.4%
o	4680	3.2%
i	4504	3.1%
t	4092	2.8%
P	3969	2.7%
n	3747	2.6%
Other values (65)	72334	49.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	60551	41.8%
Uppercase Letter	28816	19.9%
Space Separator	27976	19.3%
Decimal Number	19508	13.5%
Math Symbol	3946	2.7%
Other Punctuation	1860	1.3%
Open Punctuation	926	0.6%
Close Punctuation	920	0.6%
Dash Punctuation	343	0.2%
Other Symbol	6	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	6793	11.2%
e	6032	10.0%
r	5746	9.5%
o	4680	7.7%
i	4504	7.4%
t	4092	6.8%
n	3747	6.2%
m	3676	6.1%
l	3234	5.3%
c	3122	5.2%
Other values (15)	14925	24.6%

Uppercase Letter

Value	Count	Frequency (%)
M	4979	17.3%
P	3969	13.8%
B	3008	10.4%
G	2278	7.9%
R	2147	7.5%
D	2063	7.2%
A	1857	6.4%
C	1418	4.9%
F	1241	4.3%
O	1070	3.7%
Other values (15)	4786	16.6%

Decimal Number

Value	Count	Frequency (%)
6	3200	16.4%
1	3018	15.5%
2	2829	14.5%
0	2679	13.7%
5	2442	12.5%
8	1623	8.3%
4	1462	7.5%
3	1253	6.4%
7	589	3.0%
9	413	2.1%

Other Punctuation

Value	Count	Frequency (%)
.	1765	94.9%
,	83	4.5%
:	7	0.4%
/	2	0.1%
%	1	0.1%
?	1	0.1%
'	1	0.1%

Math Symbol

Value	Count	Frequency (%)
\|	2098	53.2%
+	1848	46.8%

Other Symbol

Value	Count	Frequency (%)
®	3	50.0%
™	3	50.0%

Space Separator

Value	Count	Frequency (%)
	27976	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	926	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	920	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	343	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	89367	61.7%
Common	55485	38.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	6793	7.6%
e	6032	6.7%
r	5746	6.4%
M	4979	5.6%
o	4680	5.2%
i	4504	5.0%
t	4092	4.6%
P	3969	4.4%
n	3747	4.2%
m	3676	4.1%
Other values (40)	41149	46.0%

Common

Value	Count	Frequency (%)
	27976	50.4%
6	3200	5.8%
1	3018	5.4%
2	2829	5.1%
0	2679	4.8%
5	2442	4.4%
\|	2098	3.8%
+	1848	3.3%
.	1765	3.2%
8	1623	2.9%
Other values (15)	6007	10.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	144846	> 99.9%
None	3	< 0.1%
Letterlike Symbols	3	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	27976	19.3%
a	6793	4.7%
e	6032	4.2%
r	5746	4.0%
M	4979	3.4%
o	4680	3.2%
i	4504	3.1%
t	4092	2.8%
P	3969	2.7%
n	3747	2.6%
Other values (63)	72328	49.9%

None

Value	Count	Frequency (%)
®	3	100.0%

Letterlike Symbols

Value	Count	Frequency (%)
™	3	100.0%

availability
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	6.7 KiB

IN_STOCK	721
COMING_SOON	93
OUT_OF_STOCK	32
PRE_ORDER	1

Length

Max length	12
Median length	8
Mean length	8.481700118
Min length	8

Characters and Unicode

Total characters	7184
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	0.1%

Sample

1st row	IN_STOCK
2nd row	IN_STOCK
3rd row	IN_STOCK
4th row	COMING_SOON
5th row	IN_STOCK

Common Values

Value	Count	Frequency (%)
IN_STOCK	721	85.1%
COMING_SOON	93	11.0%
OUT_OF_STOCK	32	3.8%
PRE_ORDER	1	0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
in_stock	721	85.1%
coming_soon	93	11.0%
out_of_stock	32	3.8%
pre_order	1	0.1%

Most occurring characters

Value	Count	Frequency (%)
O	1097	15.3%
N	907	12.6%
_	879	12.2%
S	846	11.8%
C	846	11.8%
I	814	11.3%
T	785	10.9%
K	753	10.5%
M	93	1.3%
G	93	1.3%
Other values (6)	71	1.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	6305	87.8%
Connector Punctuation	879	12.2%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
O	1097	17.4%
N	907	14.4%
S	846	13.4%
C	846	13.4%
I	814	12.9%
T	785	12.5%
K	753	11.9%
M	93	1.5%
G	93	1.5%
U	32	0.5%
Other values (5)	39	0.6%

Connector Punctuation

Value	Count	Frequency (%)
_	879	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6305	87.8%
Common	879	12.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
O	1097	17.4%
N	907	14.4%
S	846	13.4%
C	846	13.4%
I	814	12.9%
T	785	12.5%
K	753	11.9%
M	93	1.5%
G	93	1.5%
U	32	0.5%
Other values (5)	39	0.6%

Common

Value	Count	Frequency (%)
_	879	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7184	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
O	1097	15.3%
N	907	12.6%
_	879	12.2%
S	846	11.8%
C	846	11.8%
I	814	11.3%
T	785	10.9%
K	753	10.5%
M	93	1.3%
G	93	1.3%
Other values (6)	71	1.0%

selling_price
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	333
Distinct (%)	39.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24810.7686

Minimum	3780
Maximum	179900
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.7 KiB

Quantile statistics

Minimum	3780
5-th percentile	6999
Q1	10990
median	15499
Q3	24999
95-th percentile	84900
Maximum	179900
Range	176120
Interquartile range (IQR)	14009

Descriptive statistics

Standard deviation	27771.02882
Coefficient of variation (CV)	1.119313524
Kurtosis	10.19080004
Mean	24810.7686
Median Absolute Deviation (MAD)	5500
Skewness	3.077610925
Sum	21014721
Variance	771230041.7
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14999	21	2.5%
16999	20	2.4%
11999	20	2.4%
8999	17	2.0%
7499	16	1.9%
7999	16	1.9%
10999	16	1.9%
17999	15	1.8%
19999	15	1.8%
15499	14	1.7%
Other values (323)	677	79.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3780	1	0.1%
4249	1	0.1%
4490	1	0.1%
4848	1	0.1%
4990	1	0.1%
5099	1	0.1%
5149	1	0.1%
5180	1	0.1%
5887	1	0.1%
5890	2	0.2%

Value	Count	Frequency (%)
179900	1	0.1%
169900	4	0.5%
159900	2	0.2%
149999	1	0.1%
149900	2	0.2%
140300	1	0.1%
139900	3	0.4%
129990	1	0.1%
129900	8	0.9%
119900	4	0.5%

original_price
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	155
Distinct (%)	18.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	27748.35301

Minimum	4999
Maximum	179900
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.7 KiB

Quantile statistics

Minimum	4999
5-th percentile	7999
Q1	12999
median	17999
Q3	27999
95-th percentile	89900
Maximum	179900
Range	174901
Interquartile range (IQR)	15000

Descriptive statistics

Standard deviation	28466.64267
Coefficient of variation (CV)	1.025885848
Kurtosis	8.386181474
Mean	27748.35301
Median Absolute Deviation (MAD)	6500
Skewness	2.803055262
Sum	23502855
Variance	810349744.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16999	48	5.7%
18999	30	3.5%
12999	29	3.4%
17999	28	3.3%
14999	27	3.2%
9999	26	3.1%
19999	23	2.7%
13999	22	2.6%
8999	22	2.6%
7999	20	2.4%
Other values (145)	572	67.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4999	3	0.4%
5090	1	0.1%
5099	1	0.1%
5149	1	0.1%
5299	1	0.1%
5999	3	0.4%
6400	1	0.1%
6499	1	0.1%
6799	3	0.4%
6990	1	0.1%

Value	Count	Frequency (%)
179900	1	0.1%
169900	4	0.5%
159900	2	0.2%
149999	1	0.1%
149900	2	0.2%
140300	1	0.1%
139900	4	0.5%
129900	8	0.9%
119900	6	0.7%
117100	2	0.2%

currency
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.7 KiB

INR	847

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	2541
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	INR
2nd row	INR
3rd row	INR
4th row	INR
5th row	INR

Common Values

Value	Count	Frequency (%)
INR	847	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
inr	847	100.0%

Most occurring characters

Value	Count	Frequency (%)
I	847	33.3%
N	847	33.3%
R	847	33.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2541	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
I	847	33.3%
N	847	33.3%
R	847	33.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2541	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
I	847	33.3%
N	847	33.3%
R	847	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2541	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
I	847	33.3%
N	847	33.3%
R	847	33.3%

avg_rating
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	19
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.178748524

Minimum	0
Maximum	5
Zeros	22
Zeros (%)	2.6%
Negative	0
Negative (%)	0.0%
Memory size	6.7 KiB

Quantile statistics

Minimum	0
5-th percentile	3.73
Q1	4.2
median	4.3
Q3	4.4
95-th percentile	4.6
Maximum	5
Range	5
Interquartile range (IQR)	0.2

Descriptive statistics

Standard deviation	0.7236608023
Coefficient of variation (CV)	0.1731764422
Kurtosis	26.30453662
Mean	4.178748524
Median Absolute Deviation (MAD)	0.1
Skewness	-5.052953371
Sum	3539.4
Variance	0.5236849568
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
4.3	266	31.4%
4.4	139	16.4%
4.2	138	16.3%
4.6	65	7.7%
4.5	61	7.2%
4.1	41	4.8%
4	34	4.0%
4.7	26	3.1%
0	22	2.6%
3.9	20	2.4%
Other values (9)	35	4.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	22	2.6%
1.9	1	0.1%
2.9	2	0.2%
3	2	0.2%
3.4	5	0.6%
3.5	1	0.1%
3.6	2	0.2%
3.7	8	0.9%
3.8	12	1.4%
3.9	20	2.4%

Value	Count	Frequency (%)
5	2	0.2%
4.7	26	3.1%
4.6	65	7.7%
4.5	61	7.2%
4.4	139	16.4%
4.3	266	31.4%
4.2	138	16.3%
4.1	41	4.8%
4	34	4.0%
3.9	20	2.4%

ratings_count
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	387
Distinct (%)	45.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	37161.18418

Minimum	0
Maximum	912314
Zeros	22
Zeros (%)	2.6%
Negative	0
Negative (%)	0.0%
Memory size	6.7 KiB

Quantile statistics

Minimum	0
5-th percentile	17.5
Q1	874.5
median	4237
Q3	31605
95-th percentile	166805
Maximum	912314
Range	912314
Interquartile range (IQR)	30730.5

Descriptive statistics

Standard deviation	85815.34415
Coefficient of variation (CV)	2.309273669
Kurtosis	34.80297527
Mean	37161.18418
Median Absolute Deviation (MAD)	4197
Skewness	4.988764245
Sum	31475523
Variance	7364273292
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	22	2.6%
569	13	1.5%
437	13	1.5%
3091	11	1.3%
147617	11	1.3%
14716	10	1.2%
166805	9	1.1%
878	9	1.1%
78495	9	1.1%
95315	9	1.1%
Other values (377)	731	86.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	22	2.6%
3	4	0.5%
4	6	0.7%
5	3	0.4%
9	2	0.2%
12	2	0.2%
13	1	0.1%
16	3	0.4%
21	4	0.5%
23	2	0.2%

Value	Count	Frequency (%)
912314	2	0.2%
558328	2	0.2%
555584	3	0.4%
455103	1	0.1%
402335	1	0.1%
389897	1	0.1%
387289	1	0.1%
365433	1	0.1%
358524	1	0.1%
357645	1	0.1%

reviews_count
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	343
Distinct (%)	40.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2989.429752

Minimum	0
Maximum	71867
Zeros	32
Zeros (%)	3.8%
Negative	0
Negative (%)	0.0%
Memory size	6.7 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	70
median	441
Q3	2910.5
95-th percentile	11610
Maximum	71867
Range	71867
Interquartile range (IQR)	2840.5

Descriptive statistics

Standard deviation	6679.098769
Coefficient of variation (CV)	2.234238408
Kurtosis	36.91005337
Mean	2989.429752
Median Absolute Deviation (MAD)	432
Skewness	5.112904974
Sum	2532047
Variance	44610360.37
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	32	3.8%
1	21	2.5%
40	13	1.5%
55	13	1.5%
1111	12	1.4%
332	11	1.3%
11610	11	1.3%
94	10	1.2%
5921	9	1.1%
11455	9	1.1%
Other values (333)	706	83.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	32	3.8%
1	21	2.5%
2	4	0.5%
4	3	0.4%
5	4	0.5%
7	4	0.5%
8	4	0.5%
9	5	0.6%
10	5	0.6%
11	2	0.2%

Value	Count	Frequency (%)
71867	2	0.2%
54777	1	0.1%
40671	2	0.2%
39802	1	0.1%
35451	1	0.1%
33166	3	0.4%
32932	2	0.2%
29590	1	0.1%
29572	1	0.1%
28255	1	0.1%

one_stars_count
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	333
Distinct (%)	39.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1866.495868

Minimum	0
Maximum	36443
Zeros	39
Zeros (%)	4.6%
Negative	0
Negative (%)	0.0%
Memory size	6.7 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	63
median	331
Q3	1848
95-th percentile	8436.1
Maximum	36443
Range	36443
Interquartile range (IQR)	1785

Descriptive statistics

Standard deviation	4000.221087
Coefficient of variation (CV)	2.143171681
Kurtosis	26.42828956
Mean	1866.495868
Median Absolute Deviation (MAD)	320
Skewness	4.50097452
Sum	1580922
Variance	16001768.74
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	39	4.6%
17	13	1.5%
30	13	1.5%
50	12	1.4%
134	11	1.3%
6092	11	1.3%
66	10	1.2%
1085	10	1.2%
4	9	1.1%
3019	9	1.1%
Other values (323)	710	83.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	39	4.6%
1	5	0.6%
2	8	0.9%
3	5	0.6%
4	9	1.1%
5	1	0.1%
6	2	0.2%
7	4	0.5%
9	4	0.5%
10	7	0.8%

Value	Count	Frequency (%)
36443	2	0.2%
29872	3	0.4%
25713	2	0.2%
22062	1	0.1%
21185	1	0.1%
18272	1	0.1%
18243	1	0.1%
17137	2	0.2%
17083	1	0.1%
16262	1	0.1%

two_stars_count
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	289
Distinct (%)	34.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	894.1404959

Minimum	0
Maximum	20581
Zeros	44
Zeros (%)	5.2%
Negative	0
Negative (%)	0.0%
Memory size	6.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	23.5
median	141
Q3	821.5
95-th percentile	4797
Maximum	20581
Range	20581
Interquartile range (IQR)	798

Descriptive statistics

Standard deviation	2150.423879
Coefficient of variation (CV)	2.405017879
Kurtosis	33.26152216
Mean	894.1404959
Median Absolute Deviation (MAD)	137
Skewness	5.115467578
Sum	757337
Variance	4624322.861
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	44	5.2%
6	30	3.5%
4	22	2.6%
7	21	2.5%
3	20	2.4%
36	20	2.4%
15	14	1.7%
33	11	1.3%
2	11	1.3%
2212	11	1.3%
Other values (279)	643	75.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	44	5.2%
1	8	0.9%
2	11	1.3%
3	20	2.4%
4	22	2.6%
5	4	0.5%
6	30	3.5%
7	21	2.5%
8	1	0.1%
9	8	0.9%

Value	Count	Frequency (%)
20581	2	0.2%
17228	3	0.4%
13590	2	0.2%
12728	1	0.1%
10998	1	0.1%
10256	1	0.1%
10112	1	0.1%
10060	1	0.1%
8959	1	0.1%
8763	1	0.1%

three_stars_count
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	332
Distinct (%)	39.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2582.670602

Minimum	0
Maximum	63157
Zeros	34
Zeros (%)	4.0%
Negative	0
Negative (%)	0.0%
Memory size	6.7 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	61
median	357
Q3	2435
95-th percentile	12107
Maximum	63157
Range	63157
Interquartile range (IQR)	2374

Descriptive statistics

Standard deviation	6398.502806
Coefficient of variation (CV)	2.47747537
Kurtosis	34.96064601
Mean	2582.670602
Median Absolute Deviation (MAD)	351
Skewness	5.253939483
Sum	2187522
Variance	40940838.16
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	34	4.0%
1	19	2.2%
8	17	2.0%
61	13	1.5%
16	13	1.5%
6270	11	1.3%
15	10	1.2%
1087	10	1.2%
2560	9	1.1%
3750	9	1.1%
Other values (322)	702	82.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	34	4.0%
1	19	2.2%
2	4	0.5%
3	6	0.7%
4	3	0.4%
5	3	0.4%
6	7	0.8%
7	1	0.1%
8	17	2.0%
9	3	0.4%

Value	Count	Frequency (%)
63157	2	0.2%
49875	3	0.4%
41275	2	0.2%
35789	1	0.1%
35617	1	0.1%
32185	1	0.1%
31620	1	0.1%
30010	1	0.1%
27300	1	0.1%
24969	1	0.1%

four_stars_count
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	363
Distinct (%)	42.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7494.469894

Minimum	0
Maximum	181356
Zeros	33
Zeros (%)	3.9%
Negative	0
Negative (%)	0.0%
Memory size	6.7 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	142.5
median	922
Q3	6750.5
95-th percentile	31349
Maximum	181356
Range	181356
Interquartile range (IQR)	6608

Descriptive statistics

Standard deviation	17820.22977
Coefficient of variation (CV)	2.377783888
Kurtosis	33.49749995
Mean	7494.469894
Median Absolute Deviation (MAD)	911
Skewness	5.052240433
Sum	6347816
Variance	317560588.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	33	3.9%
44	16	1.9%
57	13	1.5%
24817	11	1.3%
352	11	1.3%
1	11	1.3%
51	10	1.2%
3012	10	1.2%
10994	9	1.1%
14727	9	1.1%
Other values (353)	714	84.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	33	3.9%
1	11	1.3%
2	1	0.1%
3	1	0.1%
4	3	0.4%
5	5	0.6%
6	4	0.5%
7	6	0.7%
8	4	0.5%
9	1	0.1%

Value	Count	Frequency (%)
181356	2	0.2%
126009	3	0.4%
112801	2	0.2%
93160	1	0.1%
90071	1	0.1%
89873	1	0.1%
87188	1	0.1%
83902	1	0.1%
81332	2	0.2%
72646	1	0.1%

five_stars_count
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	390
Distinct (%)	46.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24323.40732

Minimum	0
Maximum	610777
Zeros	22
Zeros (%)	2.6%
Negative	0
Negative (%)	0.0%
Memory size	6.7 KiB

Quantile statistics

Minimum	0
5-th percentile	9
Q1	542.5
median	2658
Q3	20303.5
95-th percentile	120501.3
Maximum	610777
Range	610777
Interquartile range (IQR)	19761

Descriptive statistics

Standard deviation	56116.52844
Coefficient of variation (CV)	2.307099811
Kurtosis	35.68986269
Mean	24323.40732
Median Absolute Deviation (MAD)	2616
Skewness	4.961525637
Sum	20601926
Variance	3149064764
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	22	2.6%
341	13	1.5%
483	13	1.5%
108226	11	1.3%
2508	11	1.3%
9057	10	1.2%
133124	9	1.1%
756	9	1.1%
70666	9	1.1%
60981	9	1.1%
Other values (380)	731	86.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	22	2.6%
1	3	0.4%
2	5	0.6%
3	6	0.7%
7	1	0.1%
8	5	0.6%
9	3	0.4%
11	1	0.1%
13	5	0.6%
14	1	0.1%

Value	Count	Frequency (%)
610777	2	0.2%
364949	2	0.2%
332600	3	0.4%
297336	1	0.1%
249712	1	0.1%
249171	1	0.1%
241011	1	0.1%
238088	1	0.1%
234968	1	0.1%
220080	1	0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	title	ram	brand	url	product_id	listing_id	highlights	availability	selling_price	original_price	currency	avg_rating	ratings_count	reviews_count	one_stars_count	two_stars_count	three_stars_count	four_stars_count	five_stars_count
0	POCO C31 (Royal Blue, 64 GB)	4 GB RAM	POCO	https://www.flipkart.com/poco-c31-royal-blue-64-gb/p/itm19effae969b86?pid=MOBG73E7GKQK4KZP	MOBG73E7GKQK4KZP	LSTMOBG73E7GKQK4KZPR5ICMK	4 GB RAM \| 64 GB ROM \| Expandable Upto 512 GB 16.59 cm (6.53 inch) HD+ Display 13MP + 2MP + 2MP \| 5MP Front Camera 5000 mAh Lithium-ion Polymer Battery MediaTek Helio G35 Processor	IN_STOCK	8999.0	11999.0	INR	4.4	34176	1957	1675	838	2678	6707	22278
1	POCO C31 (Shadow Gray, 64 GB)	4 GB RAM	POCO	https://www.flipkart.com/poco-c31-shadow-gray-64-gb/p/itm162375acb8370?pid=MOBG73E7UBFXXMCH	MOBG73E7UBFXXMCH	LSTMOBG73E7UBFXXMCHSM0ZN5	4 GB RAM \| 64 GB ROM \| Expandable Upto 512 GB 16.59 cm (6.53 inch) HD+ Display 13MP + 2MP + 2MP \| 5MP Front Camera 5000 mAh Lithium-ion Polymer Battery MediaTek Helio G35 Processor	IN_STOCK	8999.0	11999.0	INR	4.4	34176	1957	1675	838	2678	6707	22278
2	realme C35 (Glowing Green, 64 GB)	4 GB RAM	realme	https://www.flipkart.com/realme-c35-glowing-green-64-gb/p/itmafb045222b2cf?pid=MOBGBTHFSKHF8RAU	MOBGBTHFSKHF8RAU	LSTMOBGBTHFSKHF8RAUQONXWY	4 GB RAM \| 64 GB ROM \| Expandable Upto 1 TB 16.76 cm (6.6 inch) Full HD+ Display 50MP + 2MP + 0.3MP \| 8MP Front Camera 5000 mAh Lithium Polymer Battery Unisoc Tiger T616 Processor	IN_STOCK	11999.0	13999.0	INR	4.4	8563	590	590	200	487	1303	5983
3	OPPO K10 (Black Carbon, 128 GB)	6 GB RAM	OPPO	https://www.flipkart.com/oppo-k10-black-carbon-128-gb/p/itm6205e7e72fe0c?pid=MOBGCFUHMDFSCM9W	MOBGCFUHMDFSCM9W	LSTMOBGCFUHMDFSCM9WSL0U8O	6 GB RAM \| 128 GB ROM \| Expandable Upto 1 TB 16.74 cm (6.59 inch) Full HD+ Display 50MP + 2MP + 2MP \| 16MP Front Camera 5000 mAh Lithium Ion Battery Qualcomm Snapdragon 680 Processor 33W SUPERVOOC Charger \| Dual Speaker \| Super Adaptive Refresh Rate AI Photo Suite \| OPPO Glow Design with Dirt and Scratch Resistant	COMING_SOON	14990.0	18999.0	INR	0.0	0	0	0	0	0	0	0
4	MOTOROLA G60 (Soft Silver, 128 GB)	6 GB RAM	MOTOROLA	https://www.flipkart.com/motorola-g60-soft-silver-128-gb/p/itm7d158ff189510?pid=MOBG9CJ6G5GCFAH4	MOBG9CJ6G5GCFAH4	LSTMOBG9CJ6G5GCFAH4CCXVXL	6 GB RAM \| 128 GB ROM 17.22 cm (6.78 inch) Full HD+ Display 108MP + 8MP + 2MP \| 32MP Front Camera 6000 mAh Battery Qualcomm Snapdragon 732G Processor 120Hz Refresh Rate Stock Android Experience	IN_STOCK	16999.0	21999.0	INR	4.2	85746	8753	7080	2754	6671	19500	49741
5	realme C20 (Cool Grey, 32 GB)	2 GB RAM	realme	https://www.flipkart.com/realme-c20-cool-grey-32-gb/p/itmea1903897436b?pid=MOBGF489SQZCFHYA	MOBGF489SQZCFHYA	LSTMOBGF489SQZCFHYAGB7SDS	2 GB RAM \| 32 GB ROM \| Expandable Upto 256 GB 16.51 cm (6.5 inch) HD+ Display 8MP Rear Camera \| 5MP Front Camera 5000 mAh Battery MediaTek Helio G35 Processor	IN_STOCK	7499.0	7999.0	INR	4.4	260113	12388	13478	7719	19469	42373	177074
6	realme C20 (Cool Blue, 32 GB)	2 GB RAM	realme	https://www.flipkart.com/realme-c20-cool-blue-32-gb/p/itmea1903897436b?pid=MOBGF4894MEWZJGV	MOBGF4894MEWZJGV	LSTMOBGF4894MEWZJGVW425N5	2 GB RAM \| 32 GB ROM \| Expandable Upto 256 GB 16.51 cm (6.5 inch) HD+ Display 8MP Rear Camera \| 5MP Front Camera 5000 mAh Battery MediaTek Helio G35 Processor	IN_STOCK	7499.0	7999.0	INR	4.4	260113	12388	13478	7719	19469	42373	177074
7	POCO C31 (Royal Blue, 32 GB)	3 GB RAM	POCO	https://www.flipkart.com/poco-c31-royal-blue-32-gb/p/itm9656ebd21e0b3?pid=MOBG73E7ZBHHQ3RB	MOBG73E7ZBHHQ3RB	LSTMOBG73E7ZBHHQ3RBDYSPVO	3 GB RAM \| 32 GB ROM \| Expandable Upto 512 GB 16.59 cm (6.53 inch) HD+ Display 13MP + 2MP + 2MP \| 5MP Front Camera 5000 mAh Lithium-ion Polymer Battery MediaTek Helio G35 Processor	IN_STOCK	7999.0	10999.0	INR	4.4	29523	1709	1292	703	2362	6029	19137
8	realme 9i (Prism Blue, 64 GB)	4 GB RAM	realme	https://www.flipkart.com/realme-9i-prism-blue-64-gb/p/itm3e9987219f652?pid=MOBG9VGVKUM4XNRR	MOBG9VGVKUM4XNRR	LSTMOBG9VGVKUM4XNRRJW5YNZ	4 GB RAM \| 64 GB ROM \| Expandable Upto 1 TB 16.76 cm (6.6 inch) Full HD+ Display 50MP + 2MP + 2MP \| 16MP Front Camera 5000 mAh Lithium ion Battery Qualcomm Snapdragon 680 (SM6225) Processor	IN_STOCK	12999.0	15999.0	INR	4.5	17977	990	604	266	966	2992	13149
9	realme 9i (Prism Black, 64 GB)	4 GB RAM	realme	https://www.flipkart.com/realme-9i-prism-black-64-gb/p/itm3e9987219f652?pid=MOBG9VGVYG2XHZGR	MOBG9VGVYG2XHZGR	LSTMOBG9VGVYG2XHZGRYBJYA7	4 GB RAM \| 64 GB ROM \| Expandable Upto 1 TB 16.76 cm (6.6 inch) Full HD+ Display 50MP + 2MP + 2MP \| 16MP Front Camera 5000 mAh Lithium ion Battery Qualcomm Snapdragon 680 (SM6225) Processor	IN_STOCK	12999.0	15999.0	INR	4.5	17977	990	604	266	966	2992	13149

Last rows

	title	ram	brand	url	product_id	listing_id	highlights	availability	selling_price	original_price	currency	avg_rating	ratings_count	reviews_count	one_stars_count	two_stars_count	three_stars_count	four_stars_count	five_stars_count
837	OPPO F9 (Stellar Purple, 64 GB)	4 GB RAM	OPPO	https://www.flipkart.com/oppo-f9-stellar-purple-64-gb/p/itmf8whxzsyhhetm?pid=MOBF8WHXTX8VXSHH	MOBF8WHXTX8VXSHH	LSTMOBF8WHXTX8VXSHHJD1VQW	4 GB RAM \| 64 GB ROM \| Expandable Upto 256 GB 16.0 cm (6.3 inch) Full HD+ Display 16MP + 2MP \| 16MP Front Camera 3500 mAh Battery Mediatek Helio P60 Octacore 2.0 GHz Processor	COMING_SOON	21990.0	21990.0	INR	4.5	40638	4423	1539	664	2284	8580	27571
838	Infinix Note 5 Stylus (Bordeaux Red, 64 GB)	4 GB RAM	Infinix	https://www.flipkart.com/infinix-note-5-stylus-bordeaux-red-64-gb/p/itmfb2byf2ghgesf?pid=MOBFB2BVHAGGGBTH	MOBFB2BVHAGGGBTH	LSTMOBFB2BVHAGGGBTHIKIVXA	4 GB RAM \| 64 GB ROM \| Expandable Upto 128 GB 15.06 cm (5.93 inch) Full HD+ Display 16MP Rear Camera \| 16MP Front Camera 4000 mAh Li-ion Polymer Battery Mediatek Helio P23 Octa-core Processor	COMING_SOON	16999.0	16999.0	INR	3.9	2737	383	351	149	313	590	1334
839	SAMSUNG Galaxy A50 (Blue, 64 GB)	4 GB RAM	SAMSUNG	https://www.flipkart.com/samsung-galaxy-a50-blue-64-gb/p/itmfe4csw5hucdnn?pid=MOBFE4CSF3G2TTUV	MOBFE4CSF3G2TTUV	LSTMOBFE4CSF3G2TTUV1HA5LO	4 GB RAM \| 64 GB ROM \| Expandable Upto 512 GB 16.26 cm (6.4 inch) Full HD+ Display 25MP + 5MP + 8MP \| 25MP Front Camera 4000 mAh Lithium-ion Battery Exynos 9610 Processor Super AMOLED Display	COMING_SOON	15899.0	21000.0	INR	4.3	68093	6255	3852	1527	4549	16123	42042
840	MOTOROLA Edge 20 (Frosted Pearl, 128 GB)	8 GB RAM	MOTOROLA	https://www.flipkart.com/motorola-edge-20-frosted-pearl-128-gb/p/itmf7252c5388b02?pid=MOBGYK55HBGMBW25	MOBGYK55HBGMBW25	LSTMOBGYK55HBGMBW25J2VJML	8 GB RAM \| 128 GB ROM 17.02 cm (6.7 inch) Full HD+ Display 108MP + 8MP + 16MP \| 32MP Front Camera 4000 mAh Battery Qualcomm Snapdragon 778G Processor 144Hz Refresh Rate AMOLED Display 6.99mm Slim Design	IN_STOCK	25999.0	34999.0	INR	4.1	5288	831	560	167	380	1170	3011
841	OPPO A55 (Rainbow Blue, 128 GB)	6 GB RAM	OPPO	https://www.flipkart.com/oppo-a55-rainbow-blue-128-gb/p/itmfd07b94a9a543?pid=MOBG84AZHMTVYFBZ	MOBG84AZHMTVYFBZ	LSTMOBG84AZHMTVYFBZMOR4TE	6 GB RAM \| 128 GB ROM \| Expandable Upto 256 GB 16.54 cm (6.51 inch) HD+ Display 50MP + 2MP + 2MP \| 16MP Front Camera 5000 mAh Lithium-ion Polymer Battery MediaTek Helio G35 Processor	IN_STOCK	17490.0	20990.0	INR	4.2	135	8	11	3	13	26	82
842	OPPO A37f (Black, 16 GB)	2 GB RAM	OPPO	https://www.flipkart.com/oppo-a37f-black-16-gb/p/itmewd4kzshreqtm?pid=MOBEWMAUFU9AFWUH	MOBEWMAUFU9AFWUH	LSTMOBEWMAUFU9AFWUHHNTLTZ	2 GB RAM \| 16 GB ROM \| Expandable Upto 128 GB 12.7 cm (5 inch) HD Display 8MP Rear Camera \| 5MP Front Camera 2630 mAh Battery Snapdragon MSM 8916 Processor	COMING_SOON	9990.0	10990.0	INR	4.2	11537	1952	891	456	1134	2427	6629
843	KARBONN K9 Kavach (Champagne, 16 GB)	2 GB RAM	KARBONN	https://www.flipkart.com/karbonn-k9-kavach-champagne-16-gb/p/itmfytcspgzpu4wh?pid=MOBFYJC5CM5MHRMJ	MOBFYJC5CM5MHRMJ	LSTMOBFYJC5CM5MHRMJQGWAWV	2 GB RAM \| 16 GB ROM \| Expandable Upto 32 GB 12.7 cm (5 inch) HD Display 5MP Rear Camera 2300 mAh Battery	COMING_SOON	7490.0	7490.0	INR	4.1	2897	258	294	131	291	451	1730
844	OPPO Reno2 (Ocean Blue, 256 GB)	8 GB RAM	OPPO	https://www.flipkart.com/oppo-reno2-ocean-blue-256-gb/p/itmda87752a48a36?pid=MOBFJY8YRNGGZPVD	MOBFJY8YRNGGZPVD	LSTMOBFJY8YRNGGZPVDUGG2GJ	8 GB RAM \| 256 GB ROM \| Expandable Upto 256 GB 16.51 cm (6.5 inch) Display 48MP + 8MP + 13MP + 2MP \| 16MP Front Camera 4000 mAh Battery Qualcomm Snapdragon 730G Processor Ultra Dark Mode l Ultra Steady Video 20x Digital Zoom	COMING_SOON	39990.0	39990.0	INR	4.4	1648	199	106	41	101	279	1121
845	SAMSUNG Galaxy A53 (Light Blue, 128 GB)	8 GB RAM	SAMSUNG	https://www.flipkart.com/samsung-galaxy-a53-light-blue-128-gb/p/itm3ceac537b62e9?pid=MOBGCFVYUHHUJFNY	MOBGCFVYUHHUJFNY	LSTMOBGCFVYUHHUJFNY6GCQII	8 GB RAM \| 128 GB ROM \| Expandable Upto 1 TB 16.51 cm (6.5 inch) Full HD+ Display 64MP + 12MP + 5MP + 5MP \| 32MP Front Camera 5000 mAh Lithium Ion Battery Exynos Octa Core Processor Processor	PRE_ORDER	35999.0	40999.0	INR	0.0	0	0	0	0	0	0	0
846	YU Ace (Rose Gold, 16 GB)	2 GB RAM	YU	https://www.flipkart.com/yu-ace-rose-gold-16-gb/p/itmf8hv9kkm5djhu?pid=MOBF8HV9DHJJYXGH	MOBF8HV9DHJJYXGH	LSTMOBF8HV9DHJJYXGHDFOVEF	2 GB RAM \| 16 GB ROM \| Expandable Upto 128 GB 13.84 cm (5.45 inch) HD+ Display 13MP Rear Camera \| 5MP Front Camera 4000 mAh Polymer Battery MT6739WW Processor	COMING_SOON	7999.0	7999.0	INR	4.1	66103	8270	5079	3100	8228	15374	34322

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Math Symbol

Space Separator

Close Punctuation

Open Punctuation

Dash Punctuation

Other Symbol

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Dash Punctuation

Math Symbol

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category